Excel Conditional Formatting Query

[LeePipe]

Hi All,

I am wondering if its possible to do the following

For Example

If Cell O25 = 1 THEN BOLD CELL J25 AND L25?

I also have 30 sheets in my workbook if there is a way to apply the function to all sheets in one go

Thanks

Lee

[Syrkrasi]

Sure

- Click cell J25
- Click the Conditional Formatting button
- Create a new rule
- Select Use a formula to determine which cells to format
- Then, type =$O25=1 into the window under Format values where this formula is true:
- Next, press the FORMAT button and select BOLD in the FONT > FONT STYLE window
- Press the OK button three times
- Lastly, you may drag this field (up or down) to your required fields

Follow the above steps cell L25 as well.

see attachment

[LeePipe]

thank you very much

[Syrkrasi]

Glad to assist. Please mark this thread as SOLVED, if this concludes your initial request. Cheers