Conditional formatting based on different sheets
How can I make a cell change colour based on and IF statement.
I want one cell to go red if the value in another cell is negative, but the two cells are on different sheets so I cant use conditional formatting. Thank you. Richard |
Conditional formatting based on different sheets
Various ways, here are a couple
On the sheet you want to CF your cells, include a helper that simply refers to your If formula on the other sheet Name your If formula cell, eg "myIf" then for your CF, Formula Is, =myIf=123 change the 123 as required, or simply =myIf if the formula evaluates to true (eg a number) Of course another way would be to replicate your If formula on the CF sheet Regards, Peter T "VoxBox-Richard" wrote in message ... How can I make a cell change colour based on and IF statement. I want one cell to go red if the value in another cell is negative, but the two cells are on different sheets so I can't use conditional formatting. Thank you. Richard |
Conditional formatting based on different sheets
Hi,
You can cheat. Enter your conditional format formula on the sheet you want it to apply to. For example this in C1 of Sheet 1 looking at A1 of Sheet 4 =Sheet4!A16 Now in sheet 1 in the cell you want to conditional format, point to that cell =$C$1=TRUE Mike "VoxBox-Richard" wrote: How can I make a cell change colour based on and IF statement. I want one cell to go red if the value in another cell is negative, but the two cells are on different sheets so I cant use conditional formatting. Thank you. Richard |
Conditional formatting based on different sheets
=INDIRECT("Sheet2!A1")10
as an example -- __________________________________ HTH Bob "VoxBox-Richard" wrote in message ... How can I make a cell change colour based on and IF statement. I want one cell to go red if the value in another cell is negative, but the two cells are on different sheets so I can't use conditional formatting. Thank you. Richard |
All times are GMT +1. The time now is 03:30 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com