AUTO PROTECT CELLS AFTER ENTERING DATA ONCE SAVED

[SARJIL VHORA]

Hi,
could you help to apply conditional formatting..
i want to apply color in whole row based on data given in its single cell..

 

[Sathish KV]

Yes, you can do that

Eg: If you want to conditional format rows 2 to 10 if column A2 to A10 is not blank

You need to select those ten rows and insert conditional formatting

In the conditional formatting options use formula as =$A2<>""

Note: Keep an eye on the dollar symbol used in the above formula

 

[SARJIL VHORA]

Hi,
what i want ?? please find attached sheet....
if user enters OK in Column T then whole row containing that cell should turn into green color
if user enters NOT OK in column T then whole row containing that cell should turn into red color

 

[Sathish KV]

Select the rows from 2 to end row where you want this conditional formatting

In the conditional formatting

The first rule is formula as =$T2="OK" , select the colour you need
The second rule is formula as =$T2="NOT OK" , select the colour you need

 

[RAKESH BANDAL]

If you want to protect only columns which are in yellow color, no need to enter micros