I would like to be able to highlight cells that do not match a 000-00-0000 format. Is there a way to do this?
Please, and thank you!!!example.xlsx
I've added a document showing what I'm wanting but done manually by applying a fill.
I would like to be able to highlight cells that do not match a 000-00-0000 format. Is there a way to do this?
Please, and thank you!!!example.xlsx
I've added a document showing what I'm wanting but done manually by applying a fill.
Last edited by casey1deacon; 03-10-2023 at 10:35 AM. Reason: Attached document
Hi
please add your excel version to your profile as members will tailor their answer to the OP's version. Thx
D3:D9 cells formatted
Format cells--> custom-->000-00-0000
Last edited by kvsrinivasamurthy; 03-10-2023 at 11:33 AM.
Pl note
Array formula should be confirmed with Ctrl+Shift+Enter keys together.
If answere is satisfactory press * to add reputation.
Hi kvsrinivasamurthy,
What I'm trying to do is when the numbers are not in the correct format the color is changed.
So for example if ###-##-#### is entered it stays white, because that is correct format. But if ##-##-#### is entered it changes colors as this is an incorrect format.
Select A2:A9.
Formula for CF
Formula:Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks