Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting In and Across Sheets | Excel Discussion (Misc queries) | |||
Conditional Formatting Based of Cells Based on Data Entry in anoth | Excel Discussion (Misc queries) | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Conditional Formatting across Sheets | Excel Worksheet Functions |