highlighting a cell when using a condition formula

R

Ray

Is it possible to highlight a cell in Green if a condition in a formula is met?
e.g If D15<F16 then highlight the cell Green
 
R

Roger Govier

Hi Ray

Highlight the cell (or range of cells) where you want highlighting to occur
Format>Conditional Formatting>use dropdown to select Formula
is>=$D15<$F16>Format>Text (or Fill)>Green
If you have formatted a range of cells, then as the formula is relative, the
other cells would take the condition D16<F17 etc.

If you want all cells in the range to take the formatting based upon the one
condition, then make it absolute =$D$15<$F$16
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional formatting in Excel 2010 2
Help needed 0
conditional formatting bug? 1
Conditional Formatting? 3
If........then...... 2
Conditional Formatting Applied when Statement Not True 6
Countifa RAG auto populating data 0
cell formatting 2

Top