Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
How do I set the conditional formating for cell D2 based on the value in cell
G2? |
#2
![]() |
|||
|
|||
![]()
select cell D2
use FormatConditional formatting select Formula is and type in =G2=some value then set your format Instead of G2 *equals* some value, you can use < , = ,<=, etc "D4137" wrote: How do I set the conditional formating for cell D2 based on the value in cell G2? |
#3
![]() |
|||
|
|||
![]()
The important thing to remember about Conditional Formatting (CF) is that it
is uses Relative and Absolute Referncing just like Excel Formulas do. The second most important fact associated with CF is the fact that the cell(s) selected are the ones directly affected by the referencing. So if you select A1 and use the CF formula .. =B1=2 Then A1 will meet a TRUE condition* when B2 value equals 2 and the format will be applied to A1. The biggest mistake made by users is either selecting more than one cell, selecting one cell and trying to apply a format to another, or using incorrect cell referencing when applying format(s) to various cell(s). If you remember nothing else, remember that CF IS DEPENDENT UPON WHAT CELLS ARE SELECTED AND THE NOTATION/REFERENCING USED IN ITS FORMULA(S). It's all about (again..) Location, Location, Location! ;) * This is the basis for all CF. A CF formula will only be fufilled when all items are met to a TRUE condition. This means we can make use of operational/logical processes, such as * for the AND logical operation and + for the logical OR operation. -- Regards, Zack Barresse, aka firefytr "D4137" wrote in message ... How do I set the conditional formating for cell D2 based on the value in cell G2? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional Formatting based on Text within Text | Excel Discussion (Misc queries) | |||
conditional formatting based on column | Excel Discussion (Misc queries) | |||
Conditional Formating based on another cell | Excel Discussion (Misc queries) | |||
more than 3 conditional formating in excel | Excel Discussion (Misc queries) | |||
conditional formating - Highlighting text cells based on sales res | Excel Discussion (Misc queries) |