Conditional Formatting - Using If

[PipBoy808]

I'm trying to use formulas to create conditional formatting in a large worksheet. Using the IF function, what should I write to accomplish the following:

IF the cell contains the word "ok", fill the cell pink.

I've tried =if("OK","","") and then set the format to pink, but to no avail. Does anyone have any ideas?

 

[NARAYANK991]

Hi ,

Suppose you wish to conditionally format a range ; first select the entire range.

Now , if you wish all cells to be conditionally formatted based on if their contents are "OK" , select the option :

Format only cells that contain

Cell value equal to OK

Select the cell formatting

Click on OK.

Narayan

 

[sudipto3003]

dear pip boy,

select the range of cells you want format, go conditional formatting, new rule, select format only cells that contain, from dropdown select specific text, at next select containing, on the next box write OK, and apply.

regards

 

[Sam Mathai Chacko]

PB, you don't need an IF formula. The formula you should use is =A1="OK"

The A1 above should be the reference of the Top Left cell of your selected range. So if your range starts from D5 to X50 for example, you should select D5 and drag the selection area all the way to X50. Only then you should go to the Conditional Format window, and do as I mentioned above.