• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Conditional format. If a specified cell contains a number then number & colour a separate cell

M

MalR

Member
Hi guys. Can you give me the conditional format please. If cell C24 contains a number which is equal or greater that 1 then I want cell D4 to display the word SHEETS (bold) and colour that cell (D4) a light blue.
Thanks
MalR
 
Hi MaiR,

Formatting BOLD and LIGHT blue can be done through CF, but getting word SHEET is not possible through Conditional Format, for that you have to put formula in cell D4 and than CF the cell D4 to bold and light blue.

Regards,
 
Hi MalR,

As Sir SM suggested, not possible in CF to get word "SHEETS", you can use formula in D4, and get the result:
Something like this:
 

Attachments

  • CF Sheets.xlsx
    10.7 KB · Views: 5
Thanks very much for your help Somendra and Khalid. Your formula is exactly what I was after Khalid!
I appreciate your help guys. This thread can be closed now.
Regards
MaLR
 
You must log in or register to reply here.
Back
Top