conditional format?

  • Thread starter Thread starter Todd
  • Start date Start date
T

Todd

= if A1 is empty, turn C1, E1, G1, I1 red (if data entered)

I am trying to keep users from entering data in a range of
cells if a corresponding cell is empty. Can I get
conditional formatting to turn a cell red if a different
cell has a number larger than 0 or How can I do this?



TIA


Todd
 
Or enter
=ISBLANK($A$1)

Same Result...

Paul Corrado said:
Todd,

Highlight columns C,E,G&I then select

Format|Conditional Formatting

Under condition 1 change "Cell Value Is" to "Formula Is"

Use =$A1="" if you want the cells to turn red when the cell in column A is
blank and =$A1<>"" if you want the cells to change color when something is
input into the cell. Set the formatting to suit your needs.

HTH

PC
Click to expand...
 
Todd,

Highlight columns C,E,G&I then select

Format|Conditional Formatting

Under condition 1 change "Cell Value Is" to "Formula Is"

Use =$A1="" if you want the cells to turn red when the cell in column A is
blank and =$A1<>"" if you want the cells to change color when something is
input into the cell. Set the formatting to suit your needs.

HTH

PC
 
Answer to your Q :

1.Select any one of the cells C1, E1, G1, I1,
2.Select Menu FORMAT - CONDITIONAL FORMATING
3.Select FORMULA IS
4.Type Following as Formula: =$A1=""
5.Select the desired format if A1 is Empty (E.g Red as required by
you)
6.Click OK
7.Now you may copy this cell to any of the cells in the Row 1 i.e. if
you Formated C1, copy it to E1, G1 and I1.

Regards
Amish
*****
 
Back
Top