1

In Tab1, I want a cell (lets call it A1) to turn red if the number in a cell (say... B1) on Tab2 is negative.

Is there a way I can do this?

pnuts
  • 58,317
  • 11
  • 87
  • 139
BHive94
  • 11
  • 1
  • I've spent the last hour researching on the same issue with no result :( Apparently using another tab's cell content cannot at this point be formatted via a condition. – Nat Naydenova Jan 03 '18 at 11:42

2 Answers2

0

Select Tab1 A1 then Format, Conditional formatting..., Format cells if..., Custom formula is: 

=indirect("Tab2!B"&1)<0

choose red fill and click Done.

pnuts
  • 58,317
  • 11
  • 87
  • 139
-1

See Google Spreadsheet Conditional Formatting Based on another Cell Value for how to do this.

If you want to reference a cell from a different tab you would write 'Tab Name'!B2 instead of just B2, where 'Tab Name' is the name of the tab that you are referencing.

Community
  • 1
  • 1
Florian Minges
  • 586
  • 3
  • 9
  • 1
    My problem is not in referencing another tab, but in figuring out what formula will tell the cell to change color. – BHive94 Jan 23 '17 at 22:07